SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO




CREATE PROCEDURE [dbo].[usp_GetRecruitTopic]
	
	(
	@param_date NVARCHAR(120)

	)
	
AS
	/* SET NOCOUNT ON */
	/*SELECT id,topic FROM dbo.JOL_Recruitment WHERE start_time<=@param_date AND end_time>=@param_date */
	SELECT id,topic FROM dbo.JOL_Recruitment 
		WHERE start_time<=dateadd(dd,1,CONVERT(SMALLDATETIME,@param_date,120)) AND
			end_time>=CONVERT(SMALLDATETIME,@param_date,120)AND 
			state='True'
	RETURN




GO
